This query extracts those individuals whose companies are located in the state of Texas.
1. Browse to IQA.
2. Select Query from the drop-down list and select New.
3. Select sources:
□ Browse to the Common folder containing business objects.
□ Select CsContact twice.
Note: When you add multiple instances of a source, the system automatically appends a numeric value (beginning with the number 1) to the second and subsequent sources to distinguish between the sources. For example, if you add the CsContact business object three times, the system labels the second and third instances CsContact1 and CsContact2, respectively.
□ In the Relations area of the Sources tab, make sure the custom relation is CsContact.Company Id Equals CsContact1.Id.
4. Define the filtering rules:
□ Select the Filters tab.
□ Mode: Basic
□ Filter on CsContact.MemberType.
■ Property: CsContact.MemberType
■ Comparison: Equals
■ Value: Individual Member
■ Click the + icon to add the filter.
□ Filter on CsContact1.StateProvince.
■ Property: CsContact1.StateProvince
■ Comparison: Equals
■ Value: TX
■ Click the + icon to add the filter.
5. Define the columns to display in the output:
□ Select the Display tab.
□ Select the following columns:
■ CsContact.Id
■ CsContact.Company
■ CsContact.MemberType
■ CsContact1.StateProvince
Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.
□ Using the Order drop-down list on the Display tab, assign:
■ CsContact.Id Order 1
■ CsContact.Company Order 2
■ CsContact.MemberType Order 3
■ CsContact1.StateProvince Order 4
6. Specify the sorting priority:
□ Select the Sorting tab.
□ Sort the results by CsContact.Id.
□ Click the + icon to add your selection.
7. Save your settings.
8. Run the query.